package com.example.shoppingmall.dao;

import com.example.shoppingmall.pojo.ImpExport;
import com.example.shoppingmall.pojo.ImpState;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;

import java.util.List;

@Mapper
public interface ImpExportMapper {

    //模糊查询+分页
    public List<ImpExport> expList(@Param("import_name") String import_name, @Param("file_state") Integer file_state,
                                   @Param("pageNo") Integer pageNo, @Param("pageNum") Integer pageNum);

    //查询总条数是
    public int total(@Param("import_name") String import_name, @Param("file_state") Integer file_state);

    //查询
    public ImpExport getExp(@Param("id") Integer id);

    //查询
    public List<ImpExport> getExp2(@Param("id") Integer id);

    //新增
    public int add(ImpExport impExport);

    //修改
    public int update(ImpExport impExport);

    //查询状态List
    public List<ImpState> stateList();

}
